﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using JYH.Data;
using Newtonsoft.Json;
using JYH.Model;
using JYH.DataAccess;
using JYH.Framework;

namespace JYH.Business
{
    /// <summary>
    ///  WmsStockMaterial
    /// </summary>
    public class WmsStockMaterialBLL : BusinessBase<WmsStockMaterial>
    {
        /// <summary>
        ///  WmsStockMaterial
        /// </summary>
        public WmsStockMaterialBLL()
        {
            myDataBase = DB.D();
            this.SqlSelect = @"; Select WmsStockMaterial.*, BasMaterialInfo.MaterialNO,
                                BasMaterialInfo.MaterialDesc,BasMaterialInfo.MaterialName,
                                BasWarehouseInfo.WarehouseNO,BasWarehouseInfo.WarehouseName,
                                BasStorageInfo.StorageNO
                                From WmsStockMaterial
                                inner join BasMaterialInfo on WmsStockMaterial.MaterialID=BasMaterialInfo.MaterialID
                                inner join BasWarehouseInfo on WmsStockMaterial.WarehouseID=BasWarehouseInfo.WarehouseID
                                left JOIN BasStorageInfo on BasStorageInfo.StorageID=WmsStockMaterial.StorageID";
        }
    }
}